/*
MySQL Backup
Database: car
Backup Time: 2022-03-16 20:15:07
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `car`.`admin`;
DROP TABLE IF EXISTS `car`.`auto`;
DROP TABLE IF EXISTS `car`.`collect`;
DROP TABLE IF EXISTS `car`.`name`;
DROP TABLE IF EXISTS `car`.`orders`;
DROP TABLE IF EXISTS `car`.`relevancy`;
DROP TABLE IF EXISTS `car`.`spencer`;
DROP TABLE IF EXISTS `car`.`user`;
CREATE TABLE `admin` (
  `adminId` int NOT NULL AUTO_INCREMENT,
  `user` varchar(10) NOT NULL,
  `passWord` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `createTime` date NOT NULL,
  PRIMARY KEY (`adminId`)
) ENGINE=InnoDB AUTO_INCREMENT=1003 DEFAULT CHARSET=utf8;
CREATE TABLE `auto` (
  `autoId` int NOT NULL AUTO_INCREMENT,
  `autoName` varchar(15) NOT NULL,
  `price` int NOT NULL,
  `ran` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `energy` varchar(15) NOT NULL,
  `model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `firm` varchar(15) NOT NULL,
  `timeMarket` date DEFAULT NULL,
  `engine` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `power` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `gearbox` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `measure` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `bodyStuc` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `km` int DEFAULT NULL,
  `term` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `used` int NOT NULL,
  `utilityTime` int DEFAULT NULL,
  `mileage` int DEFAULT NULL,
  `picture` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`autoId`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;
CREATE TABLE `collect` (
  `collectId` int NOT NULL AUTO_INCREMENT,
  `userId` int NOT NULL,
  `autoId` int NOT NULL,
  PRIMARY KEY (`collectId`),
  KEY `userId` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
CREATE TABLE `name` (
  `id` int NOT NULL AUTO_INCREMENT,
  `carName` varchar(10) NOT NULL,
  `firm` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `picture` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `intro` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '简介',
  `pictureCount` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
CREATE TABLE `orders` (
  `orderId` int NOT NULL AUTO_INCREMENT,
  `userName` varchar(15) NOT NULL,
  `phone` varchar(11) NOT NULL,
  `spencerId` int NOT NULL,
  `autoId` int NOT NULL,
  `state` int NOT NULL,
  `createTime` date NOT NULL,
  PRIMARY KEY (`orderId`),
  KEY `fk_auto` (`autoId`),
  KEY `fk_spencer` (`spencerId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
CREATE TABLE `relevancy` (
  `relecancyId` int NOT NULL AUTO_INCREMENT,
  `spencerId` int NOT NULL,
  `autoId` int NOT NULL,
  `carId` int NOT NULL,
  PRIMARY KEY (`relecancyId`),
  KEY `spencer` (`spencerId`),
  KEY `auto` (`autoId`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;
CREATE TABLE `spencer` (
  `spencerId` int NOT NULL AUTO_INCREMENT,
  `spencerUser` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `spencerWord` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `spencerName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `location` varchar(50) NOT NULL,
  `userName` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `phone` varchar(11) NOT NULL,
  `state` int NOT NULL COMMENT '0：表示已注册 1：表示注销店铺 2：表示正在审核',
  `createTime` date DEFAULT NULL,
  `picture` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`spencerId`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
CREATE TABLE `user` (
  `userId` int NOT NULL AUTO_INCREMENT,
  `userName` varchar(15) NOT NULL,
  `passWord` varchar(16) NOT NULL,
  `phone` varchar(11) NOT NULL,
  `createTime` date NOT NULL,
  `state` int NOT NULL,
  PRIMARY KEY (`userId`),
  UNIQUE KEY `one` (`phone`),
  UNIQUE KEY `phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
BEGIN;
LOCK TABLES `car`.`admin` WRITE;
DELETE FROM `car`.`admin`;
INSERT INTO `car`.`admin` (`adminId`,`user`,`passWord`,`createTime`) VALUES (1001, 'admin', '123456', '2021-11-29'),(1002, 'zyx', '111111', '2021-11-23');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `car`.`auto` WRITE;
DELETE FROM `car`.`auto`;
INSERT INTO `car`.`auto` (`autoId`,`autoName`,`price`,`ran`,`energy`,`model`,`firm`,`timeMarket`,`engine`,`power`,`gearbox`,`measure`,`bodyStuc`,`km`,`term`,`used`,`utilityTime`,`mileage`,`picture`) VALUES (1, '红旗HS5', 183801, '中型SUV', '汽油机', '2022款 2.0T 智联旗悦版', '红旗', '2021-09-01', '2.0T', '165.0', '6档手自一体', '4760x1907x1700', '5门5座SUV', 210, '整车4年/10万公里', 0, NULL, NULL, '2a4ca56e6bfe4bee8d201a073e27b9d8.jpg'),(2, '汉兰达', 258800, '中型车', '汽油机', '2022款 双擎 2.5L 两驱精英版', '丰田', '2021-01-01', '2.0T', '162.0', '6档手自一体', '4890x1925x1715', '5门7座SUV', 200, '整车3年/10万公里', 0, NULL, NULL, '5713a704dc044a83b0225c594bc4ed78.jpg'),(3, '帕萨特', 179900, '中型车', '汽油机', '2022款 280TSI 商务版', '大众', '2021-08-01', '1.4T', '110.0', '7档DSG', '4948x1836x1469', '4门5座三厢轿车', 210, '整车3年/10万公里', 0, NULL, NULL, '525cda1f330b4a698fd3bbef2a56e100.jpg'),(4, '途岳', 188800, '小型车', '汽油', 'SUV', '大众', '2020-09-01', '1.4T', '110.0', '7档DSG', '4453x1841x1632', '5门5座SUV', 200, NULL, 0, NULL, NULL, 'faca5a64955147cdb4d8957c477555c9.jpg'),(5, '朗逸', 112900, '小型车', '汽油', '轿车', '大众', '2021-10-01', '1.5L', '190.0', '5档手动', '4670x1806x1474', '4门5座三厢轿车', 190, '整车3年/10万公里', 0, NULL, NULL, '91945be1f302450f83261a82faa51ac7.jpg'),(6, '途观L', 215800, '中型车', '汽油', '途观L 2022款 330TSI 自动两驱舒享版', '大众', '2021-08-01', '2.0T', '137.0', '7档DSG', '4733x1839x1673', '5门5座SUV', NULL, '整车3年/10万公里', 0, NULL, NULL, 'd4b15baf3dca42a6b1f772699c01b48c.jpg'),(7, '宝来', 82000, '小型车', '汽油', '宝来 2021款 1.5L 手动时尚智联版', '大众', '2020-11-01', '1.5L', '83.0', '5档手动', '4663x1815x1462', '4门5座三厢轿车', 190, '整车3年/10万公里', 0, NULL, NULL, '0d9dccce2050462b8a7a301195ff083d.jpg'),(8, '红旗H5', 145800, '中型车', '汽油', '红旗H5 2022款 1.5T DCT旗悦版', '红旗', '2021-09-01', '1.5T', '124.0', '7档双离合', '4945x1845x1470', '4门5座三厢轿车', 210, '整车4年/10万公里', 0, NULL, NULL, 'd480b5865ceb46e382ab2b64a48f2e94.jpg'),(9, '红旗H7', 252800, '中型车', '汽油', '红旗H7 2021款 1.8T 舒适版', '红旗', '2021-03-01', '1.8T', '138.0', '6档手自一体', '5095x1875x1485', '4门5座三厢轿车', NULL, '整车4年/10万公里', 0, NULL, NULL, '462e49cad4164671825134e018518892.jpg'),(10, '红旗HS7', 275800, '中型车', '油电混合', '红旗HS7 2022款 2.0T DCT两驱智联旗享版', '红旗', '2021-09-01', '2.0T', '185.0', '7档双离合', '5035x1989x1778', '5门5座SUV', NULL, '整车4年/10万公里', 0, NULL, NULL, 'dac8ee9152284f5ba2661380413dc614.jpg'),(11, '红旗H9', 309800, '中型车', '油电混合', '红旗H9 2022款 2.0T 智联旗享版', '红旗', '2021-11-01', '2.0T', '185.0', '7档双离合', '5137x1904x1493', '4门5座三厢轿车', 230, '整车4年/10万公里', 0, NULL, NULL, '5c229fe7712846c6a675fc2ee0315217.jpg'),(12, '埃尔法', 839000, '中型MPV', '油电混合', '埃尔法 2021款 双擎 2.5L 豪华版', '丰田', '2021-06-01', '1.8L', '70', 'ECVT', '4635x1780x1455', '4门5座三厢车', 160, '整车3年/10万公里', 0, NULL, NULL, '111b768516514b8fb790aaefb946e6e9.jpg'),(13, '卡罗拉', 121800, '紧凑型车', '油电混合', '卡罗拉 2021款 双擎 1.8L E-CVT先锋版', '丰田', '2020-07-01', '2.5L', '141', 'ECVT无级变速', '4965x1930x1750\r', '5门5座SUV', 180, '整车3年/10万公里', 0, NULL, NULL, '513a99384de34905b8237b034c170e15.jpg'),(14, '凯美瑞', 179800, '中型车', '汽油机', '凯美瑞 2021款 2.0E 精英版', '丰田', '2021-02-01', '2.0L', '131.0', '10档无级变速', '4885x1840x1455', '4门5座三厢轿车', 205, '整车3年/10万公里', 0, NULL, NULL, 'a3a448aadc9c41a6950c5d249eca8a32.jpg'),(15, '威驰', 89900, '小型车', '汽油机', '威驰 2022款 1.5L CVT创行CARE版', '丰田', '2021-11-01', '1.5L', '82.0', '8档无级变速', '4435x1700x1490', '4门5座三厢轿车', 180, '整车3年/10万公里', 0, NULL, NULL, 'c5539e8557cb4c76b2aa727454d71287.jpg'),(16, '亚洲龙', 226800, '中型车', '汽油机', '亚洲龙 2021款 2.5L 豪华版', '丰田', '2020-08-01', '2.5L', '154.0', '8档手自一体', '4975x1850x1450', '4门5座三厢轿车', NULL, '整车4年/10万公里', 0, NULL, NULL, 'bb981d4586904bd488666c5749923dd4.jpg'),(17, '轩逸', 138900, '紧凑型车', '油电混合', '轩逸 2022款 e-POWER 全电驱Pro', '东风日产', '2021-11-01', '1.2L', '53.0', '电动车单速变速箱', '4649x1815x1447', '4门5座三厢车', 165, '整车3年/10万公里', 0, NULL, NULL, '7a8c8ecb87a645f497d052b9f042031a.jpg'),(18, '奔驰C级', 369100, '中型车', '48V轻混系统', '奔驰C级 2022款 C 260 L', '奔驰', '2021-08-01', '1.5T', '150', '9挡手自一体', '4882x1820x1461\r', '4门5座三厢车', 236, '3年不限公里', 0, NULL, NULL, 'b004f2dcac7142d6825c0b8bfd33e9c5.jpg'),(19, '奔驰E级', 438100, '中大型车', '汽油机', '奔驰E级 2022款 改款 E 260 L 轿车', '奔驰', '2021-03-01', '2.0T', '145', '9挡手自一体', '5078x1860x1480', '4门5座三厢车\r\n', 227, '3年不限公里', 0, NULL, NULL, '13ecb2dec3954913be6f7c2febd54b8b.jpg'),(20, '奔驰GLC', 379200, '中型SUV', '汽油机', '奔驰GLC 2022款 GLC 260 L 4MATIC 豪华型', '奔驰', '2021-10-01', '2.0T', '145', '9挡手自一体', '4764x1898x1642', '5门5座SUV', 213, '3年不限公里', 0, NULL, NULL, '48c03be3698f4172b60a2dd1acb60dc7.jpg'),(21, '奔驰A级', 264800, '紧凑型车', '汽油机', '2022款 改款 A 200 L 运动轿车时尚版', '奔驰', '2021-01-01', '1.3T', '120', '7挡双离合', '4622x1796x1454', '4门5座三厢车', 230, '3年不限公里', 0, NULL, NULL, '9257754543f04e29803f7b9a37f7ec68.jpg'),(22, '奔驰S级', 917800, '大型车', '轻混系统', '奔驰S级 2022款 S 400 L 商务型', '奔驰', '2021-08-01', '2.5T', '230', '9挡手自一体', '5290x1921x1503\r', '4门5座三厢车', 250, '3年不限公里', 0, NULL, NULL, '45948dba8ffa48259c1c75bc4968c54c.jpg'),(23, '迈巴赫S级', 1468000, '大型车', '轻混系统', '迈巴赫S级 2021款 S 480 4MATIC', '奔驰', '2021-04-01', '3.0T', '270', '9挡手自一体', '5470x1921x1510', '4门5座三厢车', 250, '3年不限公里', 0, NULL, NULL, '1daf1bbb91a14b1fbd05579cf2febf4f.jpg'),(24, '奥迪A8L', 730000, '大型车', '轻混系统', '奥迪A8 2022款 A8L 50 TFSI quattro 舒适型典藏版', '奥迪', '2020-09-01', '3.0T', '210', '8挡手自一体', '5302x1945x1483', '4门5座三厢车', 250, '3年或10万公里\r\n', 0, NULL, NULL, 'f7d5eac4b41b4ec687cb837f46fe613c.jpg'),(25, '奥迪Q2L', 173900, '小型车', '汽油机', '2022款 35 TFSI 进取动感型', '奥迪', '2020-11-01', '1.4T', '110', '7挡双离合', '4236x1785x1548', '5门5座SUV', 200, '3年或10万公里', 0, NULL, NULL, 'b4a78af3247c42a78e4a4f632ee5fab6.jpg'),(26, '奥迪A6L', 382000, '中型车', '汽油机', '2022款 40 TFSI 豪华致雅型', '奥迪', '2020-09-01', '2.0T', '165', '7挡双离合', '5050x1886x1475', '4门5座三厢车', 245, '3年或10万公里', 0, NULL, NULL, 'dbf79e9917cf4281978242db51a539bf.jpg'),(27, '奥迪R8', 2288800, '跑车', '汽油机', '奥迪R8 2022款 V10 Coupe Performance', '奥迪', '2021-05-01', '5.2L', '456', '7挡双离合', '4429x1940x1236', '2门2座硬顶跑车', 331, '3年或10万公里', 0, NULL, NULL, '1a55a75a1a9c40598516a3fb8745304f.jpg'),(28, '奥迪Q5L', 333300, '中型车', '汽油机', '奥迪Q5L 2022款 40T 时尚动感型', '奥迪', '2021-05-01', '2.0T', '140', '7挡双离合', '4770x1893x1667', '5门5座SUV', 211, '3年或10万公里', 0, NULL, NULL, '44309f5bde6e43d18b150653153651c3.jpg'),(29, '奥迪A5', 469200, '中型车', '汽油机', '2022款 Coupe 45 TFSI quattro 臻选动感型', '奥迪', '2020-11-01', '2.0T', '185', '7挡双离合', '4765x1843x1357', '5门5座掀背车', 250, '3年或10万公里\r\n', 0, NULL, NULL, '2a177c9ee9614b928c4d721748a6267e.jpg'),(30, '思域', 128900, '紧凑型车', '汽油机', '思域 2022款 180TURBO CVT尚动版', '东风本田', '2020-07-01', '1.5T', '130', 'CVT无级变速', '4517x1799x1434', '5门5座两厢车', 200, '3年或10万公里', 0, NULL, NULL, '2f5f7885a2c04a87a9f8599962da2498.jpg'),(31, '哈弗H6', 117000, '紧凑型SUV', '汽油机', '哈弗H6 2021款 第三代 1.5T 自动乐享型', '长城汽车', '2021-12-01', '1.5T', '113', '7挡双离合', '4653x1886x1730', '5门5座SUV', NULL, '3年或10万公里', 0, NULL, NULL, '4eae4f07710e4003a35a164a03113e49.jpg'),(32, '思域', 135900, '紧凑型车', '汽油机', '思域 2020款 HATCHBACK 220TURBO CVT新锐控', '东风本田', '2021-09-01', '1.5T', '95', 'CVT无级变速', '4674x1802x1415', '4门5座三厢车', 200, '3年或10万公里', 0, NULL, NULL, NULL),(34, '思域', 141900, '紧凑型车', '汽油机', '思域 2022款 240TURBO CVT劲动版', '东风本田', '2020-09-01', '1.5T', '134', 'CVT无级变速', '4674x1802x1415', '4门5座三厢车', 200, '3年或10万公里', 0, NULL, NULL, NULL),(35, '哈弗H6', 152000, '紧凑型SUV', '汽油机', '2021款 第三代 1.5T 自动Supreme+版', '长城汽车', '2021-08-01', '2.0T', '155', '7挡双离合', '4683x1886x1730', '5门5座SUV', 200, '3年或10万公里', 0, NULL, NULL, NULL),(36, '奥迪A5', 559800, '中型车', '汽油机', '2022款 Cabriolet 45 TFSI quattro 臻选动感型', '奥迪', '2021-09-01', '2.0T', '185', '7挡双离合', '4705x1846x1359', '2门4座软顶敞篷车', 250, '3年或10万公里', 0, NULL, NULL, NULL),(37, '奥迪Q5L', 409100, '中型SUV', '汽油机', '2022款 45T 臻选动感型', '奥迪', '2021-10-01', '2.0T', '185', '7挡湿式双离合', '4770x1893x1667', '5门5座SUV', 230, '3年或10万公里', 0, NULL, NULL, NULL),(38, '奥迪A6L', 597000, '中大型车', '轻混系统', '2022款 55 TFSI quattro 旗舰动感型', '奥迪', '2021-11-01', '3.0T', '250', '7挡双离合', '5050x1886x1475', '4门5座三厢车', 250, '3年或10万公里', 0, NULL, NULL, NULL),(39, '奥迪Q2L', 268800, '小型SUV', '汽油机', '奥迪Q2L 2022款 35 TFSI 豪华动感型\r\n', '奥迪', '2021-08-01', '1.4T', '110', '7挡双离合', '4270x1785x1547', '\r\n5门5座SUV', 200, '\r\n3年或10万公里', 0, NULL, NULL, NULL),(40, '奥迪A8L', 1676000, '大型车', '轻混系统', '奥迪A8 2022款 A8L 60 TFSI quattro 尊贵型典藏版', '奥迪', '2021-09-01', '4.0T', '338', '8挡手自一体', '5302x1945x1483', '\r\n4门4座三厢车', 250, '3年或10万公里', 0, NULL, NULL, NULL),(41, '迈巴赫S级', 2388000, '大型车', '轻混系统', '迈巴赫S级 2021款 S 580 4MATIC', '奔驰', '2021-08-01', '4.0T', '3700', '9挡手自一体', '5470x1921x1510', '\r\n4门4座三厢车', 250, '3年不限公里', 0, NULL, NULL, NULL),(42, '奔驰S级', 1781700, '大型车', '轻混系统', '奔驰S级 2022款 S 500 L 4MATIC', '奔驰', '2021-11-01', '3.0T', '320', '\r\n9挡手自一体', '5320x1921x1503', '\r\n4门5座三厢车', 250, '3年不限公里', 0, NULL, NULL, NULL),(43, '奔驰A级', 169800, '紧凑型车', '汽油', '奔驰A级 2022款 A 180 L', '奔驰', '2021-10-01', '1.3T', '100', '7挡双离合', '4622x1796x1459', '4门5座三厢车', 218, '\r\n3年不限公里', 0, NULL, NULL, NULL),(44, '奔驰GLC', 471200, '中型SUV', '汽油机', '奔驰GLC 2022款 二次改款 GLC 300 L 4MATIC 豪华型', '奔驰', '2022-03-01', '2.0T', '190', '9挡手自一体', '4764x1898x1642', '5门5座SUV', 235, '3年不限公里', 0, NULL, NULL, NULL),(45, '奔驰E级', 542400, '中大型车', '汽油机', '奔驰E级 2022款 二次改款 E 300 L 尊贵型 运动轿车', '奔驰', '2022-03-01', '2.0T', '190', '\r\n9挡手自一体', '5078x1860x1480', '\r\n4门5座三厢车', 240, '3年不限公里', 0, NULL, NULL, NULL),(46, '奔驰C级', 336200, '中型车', '轻混系统', '奔驰C级 2022款 C 260 L 运动版 4MATIC', '奔驰', '2021-11-01', '1.5T', '1500', '9挡手自一体', '4882x1820x1461', '4门5座三厢车', 235, '3年不限公里', 0, NULL, NULL, NULL),(47, '轩逸', 174900, '紧凑型车', '汽油电驱', '轩逸 2022款 e-POWER 超豪华Ultra', '东风日产', '2021-11-01', '1.2L', '136', '电动车单速变速箱', '4649x1815x1445', '4门5座三厢车', 165, '3年或10万公里', 0, NULL, NULL, NULL),(48, '轩逸', 133900, '紧凑型车', '汽油', '轩逸 2022款 1.6L XL CVT智享版', '东风日产那', '2021-09-01', '1.6L', '99', 'CVT无级变速', '4641x1815x1450', '\r\n4门5座三厢车', 186, '3年或10万公里', 0, NULL, NULL, NULL),(49, '亚洲龙', 182800, '中型车', '汽油', '亚洲龙 2019款 2.0L 进取版 国VI', '丰田', '2019-09-01', '2.0L', '131', 'CVT无级变速(模拟10挡)', '4975x1850x1450', '4门5座三厢车', 205, '4年或10万公里', 0, NULL, NULL, NULL),(50, '威驰', 84800, '小型车', '汽油', '威驰 2021款 1.5L CVT舒行版', '丰田', '2020-08-01', '1.5L', '82', 'CVT无级变速(模拟8挡)', '4435x1700x1490', '\r\n4门5座三厢车', 180, '3年或10万公里', 0, NULL, NULL, NULL),(51, '凯美瑞', 260800, '中型车', '油电混合', '凯美瑞 2021款 双擎 2.5HQ 旗舰版', '丰田', '2021-02-01', '2.5L', '160', 'E-CVT无级变速', '4885x1840x1455', '4门5座三厢车', 180, '3年或10万公里', 0, NULL, NULL, NULL),(52, '卡罗拉', 190800, '紧凑型车', '汽油', '卡罗拉 2021款 1.2T S-CVT旗舰版', '丰田', '2020-07-01', '1.2T', '85', 'CVT无级变速(模拟10挡)', '4635x1780x1455', '4门5座三厢车', 180, '3年或10万公里', 0, NULL, NULL, NULL),(53, '埃尔法', 920000, '中型MPV', '油电混合', '埃尔法 2021款 双擎 2.5L 臻享版', '丰田', '2021-06-01', '2.5L', '120', 'E-CVT无级变速', '4975x1850x1945', '5门7座MPV\r\n', NULL, '3年或10万公里', 0, NULL, NULL, NULL),(54, '红旗H9', 369800, '中大型车', '轻混系统', '红旗H9 2020款 2.0T 智联旗畅版', '红旗', '2020-08-01', '2.0T', NULL, '7挡双离合', '5137x1904x1493', '4门5座三厢车', 230, '4年或10万公里(首任车主不限年限/不限里程)', 0, NULL, NULL, NULL),(55, '红旗HS7', 449800, '中大型SUV', '汽油', '红旗HS7 2022款 3.0T 自动四驱智联旗领版', '红旗', '2021-09-01', '3.0T', '248', '8挡手自一体', '5035x1989x1756', '\r\n5门5座SUV', NULL, '4年或10万公里(首任车主不限年限/不限里程)', 0, NULL, NULL, NULL),(56, '红旗H7', 278800, '中大型车', '汽油', '红旗H7 2021款 2.0T 旗舰版', '红旗', '2021-03-01', '2.0T', '150', '6挡手自一体', '5095x1875x1485', '\r\n4门5座三厢车', 200, '4年或10万公里', 0, NULL, NULL, NULL),(57, '红旗H5', 180800, '中型车', '轻混系统', '红旗H5 2022款 1.8T 自动智联旗领版', '红旗', '2021-09-01', '1.8T', NULL, '6挡手自一体', '4945x1845x1470', '4门5座三厢车', 220, '4年或10万公里', 0, NULL, NULL, NULL),(58, '宝来', 127000, '紧凑型车', '汽油', '宝来 2021款 280TSI DSG豪华智联版\r\n', '大众', '2020-11-01', '1.4T', '110', '7挡双离合', '4663x1815x1473', '\r\n4门5座三厢车', 200, '3年或10万公里', 0, NULL, NULL, NULL),(59, '途观L', 254800, '中型SUV', '汽油', '途观L 2022款 380TSI 自动四驱R-Line旗舰版7座', '大众', '2021-08-01', '2.0T', '162', '7挡双离合', '4735x1859x1677', '5门7座SUV', NULL, '\r\n3年或10万公里', 0, NULL, NULL, NULL);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `car`.`collect` WRITE;
DELETE FROM `car`.`collect`;
INSERT INTO `car`.`collect` (`collectId`,`userId`,`autoId`) VALUES (1, 1, 2),(2, 1, 3),(3, 2, 2),(4, 3, 2),(5, 5, 2),(6, 3, 10),(7, 4, 11),(8, 9, 30),(9, 8, 1),(10, 7, 16),(11, 9, 15),(12, 10, 31),(14, 13, 24),(15, 12, 25),(16, 13, 22),(17, 1, 1),(18, 5, 28),(19, 9, 9),(20, 8, 26);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `car`.`name` WRITE;
DELETE FROM `car`.`name`;
INSERT INTO `car`.`name` (`id`,`carName`,`firm`,`picture`,`intro`,`pictureCount`) VALUES (1, '红旗HS5', '红旗', '2a4ca56e6bfe4bee8d201a073e27b9d8.jpg', NULL, 0),(2, '汉兰达', '丰田', '5713a704dc044a83b0225c594bc4ed78.jpg', NULL, 0),(3, '帕萨特', '大众', '525cda1f330b4a698fd3bbef2a56e100.jpg', NULL, 0),(4, '途岳', '大众', 'faca5a64955147cdb4d8957c477555c9.jpg', NULL, 0),(5, '朗逸', '大众', '91945be1f302450f83261a82faa51ac7.jpg', NULL, 0),(6, '途观L', '大众', 'd4b15baf3dca42a6b1f772699c01b48c.jpg', NULL, 0),(7, '宝来', '大众', '0d9dccce2050462b8a7a301195ff083d.jpg', NULL, 0),(8, '红旗H5', '红旗', 'd480b5865ceb46e382ab2b64a48f2e94.jpg', NULL, 0),(9, '红旗H7', '红旗', '462e49cad4164671825134e018518892.jpg', NULL, 0),(10, '红旗HS7', '红旗', 'dac8ee9152284f5ba2661380413dc614.jpg', NULL, 0),(11, '红旗H9', '红旗', '5c229fe7712846c6a675fc2ee0315217.jpg', NULL, 0),(12, '埃尔法', '丰田', '111b768516514b8fb790aaefb946e6e9.jpg', NULL, 0),(13, '卡罗拉', '丰田', '513a99384de34905b8237b034c170e15.jpg', NULL, 0),(14, '凯美瑞', '丰田', 'a3a448aadc9c41a6950c5d249eca8a32.jpg', NULL, 0),(15, '威驰', '丰田', 'c5539e8557cb4c76b2aa727454d71287.jpg', NULL, 0),(16, '亚洲龙', '丰田', 'bb981d4586904bd488666c5749923dd4.jpg', NULL, 0),(17, '轩逸', '东风日产', '7a8c8ecb87a645f497d052b9f042031a.jpg', NULL, 0),(18, '奔驰C级', '奔驰', 'b004f2dcac7142d6825c0b8bfd33e9c5.jpg', NULL, 0),(19, '奔驰E级', '奔驰', '13ecb2dec3954913be6f7c2febd54b8b.jpg', NULL, 0),(20, '奔驰GLC', '奔驰', '48c03be3698f4172b60a2dd1acb60dc7.jpg', NULL, 0),(21, '奔驰A级', '奔驰', '9257754543f04e29803f7b9a37f7ec68.jpg', NULL, 0),(22, '奔驰S级', '奔驰', '45948dba8ffa48259c1c75bc4968c54c.jpg', NULL, 0),(23, '迈巴赫S级', '奔驰', '1daf1bbb91a14b1fbd05579cf2febf4f.jpg', NULL, 0),(24, '奥迪A8L', '奥迪', 'f7d5eac4b41b4ec687cb837f46fe613c.jpg', NULL, 0),(25, '奥迪Q2L', '奥迪', 'b4a78af3247c42a78e4a4f632ee5fab6.jpg', NULL, 0),(26, '奥迪A6L', '奥迪', 'dbf79e9917cf4281978242db51a539bf.jpg', NULL, 0),(27, '奥迪R8', '奥迪', '1a55a75a1a9c40598516a3fb8745304f.jpg', NULL, 0),(28, '奥迪Q5L', '奥迪', '44309f5bde6e43d18b150653153651c3.jpg', NULL, 0),(29, '奥迪A5', '奥迪', '2a177c9ee9614b928c4d721748a6267e.jpg', NULL, 0),(30, '思域', '东风本田', '2f5f7885a2c04a87a9f8599962da2498.jpg', NULL, 0),(31, '哈弗H6', '长城汽车', '4eae4f07710e4003a35a164a03113e49.jpg', NULL, 0);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `car`.`orders` WRITE;
DELETE FROM `car`.`orders`;
INSERT INTO `car`.`orders` (`orderId`,`userName`,`phone`,`spencerId`,`autoId`,`state`,`createTime`) VALUES (1, '张先生', '17530123061', 1, 24, 1, '2021-12-07'),(7, '李先生', '17530123062', 2, 4, 0, '2022-03-10');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `car`.`relevancy` WRITE;
DELETE FROM `car`.`relevancy`;
INSERT INTO `car`.`relevancy` (`relecancyId`,`spencerId`,`autoId`,`carId`) VALUES (5, 1, 28, 28),(6, 1, 29, 29),(8, 2, 4, 4),(9, 2, 5, 5),(10, 2, 6, 6),(11, 2, 7, 7),(12, 4, 18, 18),(13, 4, 19, 19),(14, 4, 20, 20),(15, 4, 21, 21),(16, 4, 22, 22),(17, 4, 23, 23),(18, 5, 2, 2),(19, 5, 12, 12),(20, 5, 13, 13),(21, 5, 14, 14),(22, 5, 15, 15),(24, 7, 5, 5),(25, 7, 6, 6),(26, 7, 1, 1),(27, 7, 9, 9),(28, 7, 8, 8),(29, 7, 4, 4),(30, 7, 6, 6),(32, 1, 40, 24),(37, 1, 27, 27),(39, 1, 36, 29),(41, 1, 24, 24),(42, 1, 25, 25),(43, 1, 26, 26),(44, 1, 38, 26);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `car`.`spencer` WRITE;
DELETE FROM `car`.`spencer`;
INSERT INTO `car`.`spencer` (`spencerId`,`spencerUser`,`spencerWord`,`spencerName`,`location`,`userName`,`phone`,`state`,`createTime`,`picture`) VALUES (1, '17530123061', '123456', '奥迪出行北京店', '北京朝阳区东凤路', '胡老板', '17530123069', 0, '2021-12-01', '9daeadf39d7c41749a18722647ac8f0c.png'),(2, '17530123062', '123456', '大众上联汽车销售有限公司', '河南省郑州市管城区', '杨老板', '17530123062', 0, '2021-12-03', ''),(3, '17530123063', '123', '比亚迪汽车贸池', '上海市金山区', '周老板', '17530123063', 0, '2021-12-05', ''),(4, '17530123064', '123456', '浙江鹏龙之奔', '浙江省杭州市拱墅区', '黄老板', '17530123064', 0, '2021-12-06', ''),(5, '17530123065', '123456', '广汽丰田裕龙店', '深圳市龙岗区', '张老板', '17530123065', 0, '2021-12-07', ''),(6, '17530123066', '123456', '东风本田俊达店', '广东省广州市番禺区', '李老板', '17530123066', 0, '2021-12-07', ''),(7, '17530123067', '123456', '成都宝悦', '四川省成都市金牛区', '王老板', '17530123067', 0, '2021-12-07', ''),(8, '17530123068', '123456', '湖北三环汇海', '湖北省武汉市西湖区', '马老板', '17530123068', 0, '2021-12-07', ''),(9, '17530123069', '123456', '宁南保时捷中心', '江苏省南京市雨花台区', '赵老板', '17530123069', 0, '2021-12-07', '');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `car`.`user` WRITE;
DELETE FROM `car`.`user`;
INSERT INTO `car`.`user` (`userId`,`userName`,`passWord`,`phone`,`createTime`,`state`) VALUES (1, 'weiqi', '17530123011', '17530123012', '2021-12-01', 0),(2, '张', '123456', '17530123061', '2021-12-12', 0),(3, '李四', '123', '17530123068', '2021-12-22', 0),(4, '王五', '123456', '17530123063', '2022-02-10', 0),(5, '张三0', '123456', '17530123050', '2022-02-11', 3),(6, '张三1', '123456', '17530123051', '2022-02-11', 0),(7, '张三2', '123456', '17530123052', '2022-02-11', 0),(8, '张三3', '123456', '17530123053', '2022-02-11', 0),(9, '张三4', '123456', '17530123054', '2022-02-11', 0),(10, '张三5', '123456', '17530123055', '2022-02-11', 0),(11, '张三6', '123456', '17530123056', '2022-02-11', 0),(12, '张三7', '123456', '17530123057', '2022-02-11', 0),(13, '张三8', '123456', '17530123058', '2022-02-11', 0),(14, '张三9', '123456', '17530123059', '2022-02-11', 0),(15, 'lisi', '123456', '17530123069', '2022-02-12', 0),(34, '麻子', '123456', '17530123065', '2022-03-08', 0),(35, '赵六', '123456', '17530123062', '2022-03-08', 0),(36, '小李', '123456', '17530123064', '2022-03-08', 0);
UNLOCK TABLES;
COMMIT;
